﻿<?xml version="1.0" encoding="utf-8"?>
<Database xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Name="NORTHWND">
  <Table Name="ActiveProductsFedarated">
    <Type Name="nwind.ActiveProductsFedarated">
      <Column Name="ProductID" Member="ProductID" Storage="_ProductID" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="True" IsDBGenerated="True" AutoSync="OnInsert" />
      <Column Name="ProductName" Member="ProductName" Storage="_ProductName" DbType="NVarChar(40) NOT NULL" CanBeNull="False" />
    </Type>
  </Table>
  <Table Name="AddressSplit">
    <Type Name="nwind.AddressSplit">
      <Column Name="ID" Member="ID" Storage="_ID" DbType="Int NOT NULL" IsPrimaryKey="True" />
      <Column Name="Address" Member="Address" Storage="_Address" DbType="NVarChar(60)" />
      <Column Name="City" Member="City" Storage="_City" DbType="NVarChar(15)" />
      <Column Name="Region" Member="Region" Storage="_Region" DbType="NVarChar(15)" />
      <Column Name="PostalCode" Member="PostalCode" Storage="_PostalCode" DbType="NVarChar(50)" />
      <Column Name="Country" Member="Country" Storage="_Country" DbType="NVarChar(15)" />
      <Column Name="ContactType" Member="ContactType" Storage="_ContactType" DbType="NVarChar(50)" />
    </Type>
  </Table>
  <Table Name="Alphabetical list of products">
    <Type Name="nwind.AlphabeticalListOfProduct">
      <Column Name="ProductID" Member="ProductID" Storage="_ProductID" DbType="Int NOT NULL IDENTITY" />
      <Column Name="ProductName" Member="ProductName" Storage="_ProductName" DbType="NVarChar(40) NOT NULL" CanBeNull="False" />
      <Column Name="SupplierID" Member="SupplierID" Storage="_SupplierID" DbType="Int" />
      <Column Name="CategoryID" Member="CategoryID" Storage="_CategoryID" DbType="Int" />
      <Column Name="QuantityPerUnit" Member="QuantityPerUnit" Storage="_QuantityPerUnit" DbType="NVarChar(20)" />
      <Column Name="UnitPrice" Member="UnitPrice" Storage="_UnitPrice" DbType="Money" />
      <Column Name="UnitsInStock" Member="UnitsInStock" Storage="_UnitsInStock" DbType="SmallInt" />
      <Column Name="UnitsOnOrder" Member="UnitsOnOrder" Storage="_UnitsOnOrder" DbType="SmallInt" />
      <Column Name="ReorderLevel" Member="ReorderLevel" Storage="_ReorderLevel" DbType="SmallInt" />
      <Column Name="Discontinued" Member="Discontinued" Storage="_Discontinued" DbType="Bit NOT NULL" />
      <Column Name="CategoryName" Member="CategoryName" Storage="_CategoryName" DbType="NVarChar(15) NOT NULL" CanBeNull="False" />
    </Type>
  </Table>
  <Table Name="BaseContactSplit">
    <Type Name="nwind.BaseContactSplit">
      <Column Name="ID" Member="ID" Storage="_ID" DbType="Int NOT NULL" IsPrimaryKey="True" />
      <Column Name="CompanyName" Member="CompanyName" Storage="_CompanyName" DbType="NVarChar(40) NOT NULL" CanBeNull="False" />
      <Column Name="ContactName" Member="ContactName" Storage="_ContactName" DbType="NVarChar(30)" />
      <Column Name="Phone" Member="Phone" Storage="_Phone" DbType="NVarChar(24)" />
      <Column Name="ContactType" Member="ContactType" Storage="_ContactType" DbType="NVarChar(50)" />
    </Type>
  </Table>
  <Table Name="BaseProductsFedarated">
    <Type Name="nwind.BaseProductsFedarated">
      <Column Name="ProductID" Member="ProductID" Storage="_ProductID" DbType="Int NOT NULL" IsPrimaryKey="True" />
      <Column Name="ProductName" Member="ProductName" Storage="_ProductName" DbType="NVarChar(40) NOT NULL" CanBeNull="False" />
    </Type>
  </Table>
  <Table Name="Categories">
    <Type Name="nwind.Category">
      <Column Name="CategoryID" Member="CategoryID" Storage="_CategoryID" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="True" IsDBGenerated="True" AutoSync="OnInsert" />
      <Column Name="CategoryName" Member="CategoryName" Storage="_CategoryName" DbType="NVarChar(15) NOT NULL" CanBeNull="False" />
      <Column Name="Description" Member="Description" Storage="_Description" DbType="NText" UpdateCheck="Never" />
      <Column Name="Picture" Member="Picture" Storage="_Picture" DbType="Image" UpdateCheck="Never" />
      <Association Name="FK_Products_Categories" Member="Products" Storage="_Products" ThisKey="CategoryID" OtherTable="Products" OtherKey="CategoryID" DeleteRule="NO ACTION" />
    </Type>
  </Table>
  <Table Name="Category Sales for 1997">
    <Type Name="nwind.CategorySalesFor1997">
      <Column Name="CategoryName" Member="CategoryName" Storage="_CategoryName" DbType="NVarChar(15) NOT NULL" CanBeNull="False" />
      <Column Name="CategorySales" Member="CategorySales" Storage="_CategorySales" DbType="Money" />
    </Type>
  </Table>
  <Table Name="ContactNameSplit">
    <Type Name="nwind.ContactNameSplit">
      <Column Name="ID" Member="ID" Storage="_ID" DbType="Int NOT NULL" IsPrimaryKey="True" />
      <Column Name="Name" Member="Name" Storage="_Name" DbType="NVarChar(30)" />
      <Column Name="Title" Member="Title" Storage="_Title" DbType="NVarChar(30)" />
      <Column Name="Fax" Member="Fax" Storage="_Fax" DbType="NVarChar(24)" />
      <Column Name="ContactType" Member="ContactType" Storage="_ContactType" DbType="NVarChar(50)" />
    </Type>
  </Table>
  <Table Name="Contacts">
    <Type Name="nwind.Contact">
      <Column Name="ContactID" Member="ContactID" Storage="_ContactID" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="True" IsDBGenerated="True" AutoSync="OnInsert" />
      <Column Name="ContactType" Member="ContactType" Storage="_ContactType" DbType="NVarChar(50)" />
      <Column Name="CompanyName" Member="CompanyName" Storage="_CompanyName" DbType="NVarChar(40) NOT NULL" CanBeNull="False" />
      <Column Name="ContactName" Member="ContactName" Storage="_ContactName" DbType="NVarChar(30)" />
      <Column Name="ContactTitle" Member="ContactTitle" Storage="_ContactTitle" DbType="NVarChar(30)" />
      <Column Name="Address" Member="Address" Storage="_Address" DbType="NVarChar(60)" />
      <Column Name="City" Member="City" Storage="_City" DbType="NVarChar(15)" />
      <Column Name="Region" Member="Region" Storage="_Region" DbType="NVarChar(15)" />
      <Column Name="PostalCode" Member="PostalCode" Storage="_PostalCode" DbType="NVarChar(10)" />
      <Column Name="Country" Member="Country" Storage="_Country" DbType="NVarChar(15)" />
      <Column Name="Phone" Member="Phone" Storage="_Phone" DbType="NVarChar(24)" />
      <Column Name="Extension" Member="Extension" Storage="_Extension" DbType="NVarChar(4)" />
      <Column Name="Fax" Member="Fax" Storage="_Fax" DbType="NVarChar(24)" />
      <Column Name="HomePage" Member="HomePage" Storage="_HomePage" DbType="NText" UpdateCheck="Never" />
      <Column Name="PhotoPath" Member="PhotoPath" Storage="_PhotoPath" DbType="NVarChar(255)" />
      <Column Name="Photo" Member="Photo" Storage="_Photo" DbType="Image" UpdateCheck="Never" />
    </Type>
  </Table>
  <Table Name="Current Product List">
    <Type Name="nwind.CurrentProductList">
      <Column Name="ProductID" Member="ProductID" Storage="_ProductID" DbType="Int NOT NULL IDENTITY" />
      <Column Name="ProductName" Member="ProductName" Storage="_ProductName" DbType="NVarChar(40) NOT NULL" CanBeNull="False" />
    </Type>
  </Table>
  <Table Name="Customer and Suppliers by City">
    <Type Name="nwind.CustomerAndSuppliersByCity">
      <Column Name="City" Member="City" Storage="_City" DbType="NVarChar(15)" />
      <Column Name="CompanyName" Member="CompanyName" Storage="_CompanyName" DbType="NVarChar(40) NOT NULL" CanBeNull="False" />
      <Column Name="ContactName" Member="ContactName" Storage="_ContactName" DbType="NVarChar(30)" />
      <Column Name="Relationship" Member="Relationship" Storage="_Relationship" DbType="VarChar(9) NOT NULL" CanBeNull="False" />
    </Type>
  </Table>
  <Table Name="CustomerCustomerDemo">
    <Type Name="nwind.CustomerCustomerDemo">
      <Column Name="CustomerID" Member="CustomerID" Storage="_CustomerID" DbType="NChar(5) NOT NULL" CanBeNull="False" IsPrimaryKey="True" />
      <Column Name="CustomerTypeID" Member="CustomerTypeID" Storage="_CustomerTypeID" DbType="NChar(10) NOT NULL" CanBeNull="False" IsPrimaryKey="True" />
      <Association Name="FK_CustomerCustomerDemo" Member="CustomerDemographic" Storage="_CustomerDemographic" ThisKey="CustomerTypeID" OtherTable="CustomerDemographics" OtherKey="CustomerTypeID" IsForeignKey="True" />
      <Association Name="FK_CustomerCustomerDemo_Customers" Member="Customer" Storage="_Customer" ThisKey="CustomerID" OtherTable="Customers" OtherKey="CustomerID" IsForeignKey="True" />
    </Type>
  </Table>
  <Table Name="CustomerDemographics">
    <Type Name="nwind.CustomerDemographic">
      <Column Name="CustomerTypeID" Member="CustomerTypeID" Storage="_CustomerTypeID" DbType="NChar(10) NOT NULL" CanBeNull="False" IsPrimaryKey="True" />
      <Column Name="CustomerDesc" Member="CustomerDesc" Storage="_CustomerDesc" DbType="NText" UpdateCheck="Never" />
      <Association Name="FK_CustomerCustomerDemo" Member="CustomerCustomerDemos" Storage="_CustomerCustomerDemos" ThisKey="CustomerTypeID" OtherTable="CustomerCustomerDemo" OtherKey="CustomerTypeID" DeleteRule="NO ACTION" />
    </Type>
  </Table>
  <Table Name="Customers">
    <Type Name="nwind.Customer">
      <Column Name="CustomerID" Member="CustomerID" Storage="_CustomerID" DbType="NChar(5) NOT NULL" CanBeNull="False" IsPrimaryKey="True" />
      <Column Name="CompanyName" Member="CompanyName" Storage="_CompanyName" DbType="NVarChar(40) NOT NULL" CanBeNull="False" />
      <Column Name="ContactName" Member="ContactName" Storage="_ContactName" DbType="NVarChar(30)" />
      <Column Name="ContactTitle" Member="ContactTitle" Storage="_ContactTitle" DbType="NVarChar(30)" />
      <Column Name="Address" Member="Address" Storage="_Address" DbType="NVarChar(60)" />
      <Column Name="City" Member="City" Storage="_City" DbType="NVarChar(15)" />
      <Column Name="Region" Member="Region" Storage="_Region" DbType="NVarChar(15)" />
      <Column Name="PostalCode" Member="PostalCode" Storage="_PostalCode" DbType="NVarChar(10)" />
      <Column Name="Country" Member="Country" Storage="_Country" DbType="NVarChar(15)" />
      <Column Name="Phone" Member="Phone" Storage="_Phone" DbType="NVarChar(24)" />
      <Column Name="Fax" Member="Fax" Storage="_Fax" DbType="NVarChar(24)" />
      <Association Name="FK_CustomerCustomerDemo_Customers" Member="CustomerCustomerDemos" Storage="_CustomerCustomerDemos" ThisKey="CustomerID" OtherTable="CustomerCustomerDemo" OtherKey="CustomerID" DeleteRule="NO ACTION" />
      <Association Name="FK_Orders_Customers" Member="Orders" Storage="_Orders" ThisKey="CustomerID" OtherTable="Orders" OtherKey="CustomerID" DeleteRule="NO ACTION" />
    </Type>
  </Table>
  <Table Name="DiscontinuedProductsFedarated">
    <Type Name="nwind.DiscontinuedProductsFedarated">
      <Column Name="ProductID" Member="ProductID" Storage="_ProductID" DbType="Int NOT NULL" IsPrimaryKey="True" />
      <Column Name="ProductName" Member="ProductName" Storage="_ProductName" DbType="NVarChar(40) NOT NULL" CanBeNull="False" />
    </Type>
  </Table>
  <Table Name="Employees">
    <Type Name="nwind.Employee">
      <Column Name="EmployeeID" Member="EmployeeID" Storage="_EmployeeID" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="True" IsDBGenerated="True" AutoSync="OnInsert" />
      <Column Name="LastName" Member="LastName" Storage="_LastName" DbType="NVarChar(20) NOT NULL" CanBeNull="False" />
      <Column Name="FirstName" Member="FirstName" Storage="_FirstName" DbType="NVarChar(10) NOT NULL" CanBeNull="False" />
      <Column Name="Title" Member="Title" Storage="_Title" DbType="NVarChar(30)" />
      <Column Name="TitleOfCourtesy" Member="TitleOfCourtesy" Storage="_TitleOfCourtesy" DbType="NVarChar(25)" />
      <Column Name="BirthDate" Member="BirthDate" Storage="_BirthDate" DbType="DateTime" />
      <Column Name="HireDate" Member="HireDate" Storage="_HireDate" DbType="DateTime" />
      <Column Name="Address" Member="Address" Storage="_Address" DbType="NVarChar(60)" />
      <Column Name="City" Member="City" Storage="_City" DbType="NVarChar(15)" />
      <Column Name="Region" Member="Region" Storage="_Region" DbType="NVarChar(15)" />
      <Column Name="PostalCode" Member="PostalCode" Storage="_PostalCode" DbType="NVarChar(10)" />
      <Column Name="Country" Member="Country" Storage="_Country" DbType="NVarChar(15)" />
      <Column Name="HomePhone" Member="HomePhone" Storage="_HomePhone" DbType="NVarChar(24)" />
      <Column Name="Extension" Member="Extension" Storage="_Extension" DbType="NVarChar(4)" />
      <Column Name="Photo" Member="Photo" Storage="_Photo" DbType="Image" UpdateCheck="Never" />
      <Column Name="Notes" Member="Notes" Storage="_Notes" DbType="NText" UpdateCheck="Never" />
      <Column Name="ReportsTo" Member="ReportsTo" Storage="_ReportsTo" DbType="Int" />
      <Column Name="PhotoPath" Member="PhotoPath" Storage="_PhotoPath" DbType="NVarChar(255)" />
      <Association Name="FK_Employees_Employees" Member="ReportsToEmployee" Storage="_ReportsToEmployee" ThisKey="ReportsTo" OtherTable="Employees" OtherKey="EmployeeID" IsForeignKey="True" />
      <Association Name="FK_Employees_Employees" Member="Employees" Storage="_Employees" ThisKey="EmployeeID" OtherTable="Employees" OtherKey="ReportsTo" DeleteRule="NO ACTION" />
      <Association Name="FK_EmployeeTerritories_Employees" Member="EmployeeTerritories" Storage="_EmployeeTerritories" ThisKey="EmployeeID" OtherTable="EmployeeTerritories" OtherKey="EmployeeID" DeleteRule="NO ACTION" />
      <Association Name="FK_Orders_Employees" Member="Orders" Storage="_Orders" ThisKey="EmployeeID" OtherTable="Orders" OtherKey="EmployeeID" DeleteRule="NO ACTION" />
    </Type>
  </Table>
  <Table Name="EmployeeSplit">
    <Type Name="nwind.EmployeeSplit">
      <Column Name="ID" Member="ID" Storage="_ID" DbType="Int NOT NULL" IsPrimaryKey="True" />
      <Column Name="Extension" Member="Extension" Storage="_Extension" DbType="NVarChar(4)" />
      <Column Name="PhotoPath" Member="PhotoPath" Storage="_PhotoPath" DbType="NVarChar(255)" />
    </Type>
  </Table>
  <Table Name="EmployeeTerritories">
    <Type Name="nwind.EmployeeTerritory">
      <Column Name="EmployeeID" Member="EmployeeID" Storage="_EmployeeID" DbType="Int NOT NULL" IsPrimaryKey="True" />
      <Column Name="TerritoryID" Member="TerritoryID" Storage="_TerritoryID" DbType="NVarChar(20) NOT NULL" CanBeNull="False" IsPrimaryKey="True" />
      <Association Name="FK_EmployeeTerritories_Employees" Member="Employee" Storage="_Employee" ThisKey="EmployeeID" OtherTable="Employees" OtherKey="EmployeeID" IsForeignKey="True" />
      <Association Name="FK_EmployeeTerritories_Territories" Member="Territory" Storage="_Territory" ThisKey="TerritoryID" OtherTable="Territories" OtherKey="TerritoryID" IsForeignKey="True" />
    </Type>
  </Table>
  <Table Name="Invoices">
    <Type Name="nwind.Invoices">
      <Column Name="ShipName" Member="ShipName" Storage="_ShipName" DbType="NVarChar(40)" />
      <Column Name="ShipAddress" Member="ShipAddress" Storage="_ShipAddress" DbType="NVarChar(60)" />
      <Column Name="ShipCity" Member="ShipCity" Storage="_ShipCity" DbType="NVarChar(15)" />
      <Column Name="ShipRegion" Member="ShipRegion" Storage="_ShipRegion" DbType="NVarChar(15)" />
      <Column Name="ShipPostalCode" Member="ShipPostalCode" Storage="_ShipPostalCode" DbType="NVarChar(10)" />
      <Column Name="ShipCountry" Member="ShipCountry" Storage="_ShipCountry" DbType="NVarChar(15)" />
      <Column Name="CustomerID" Member="CustomerID" Storage="_CustomerID" DbType="NChar(5)" />
      <Column Name="CustomerName" Member="CustomerName" Storage="_CustomerName" DbType="NVarChar(40) NOT NULL" CanBeNull="False" />
      <Column Name="Address" Member="Address" Storage="_Address" DbType="NVarChar(60)" />
      <Column Name="City" Member="City" Storage="_City" DbType="NVarChar(15)" />
      <Column Name="Region" Member="Region" Storage="_Region" DbType="NVarChar(15)" />
      <Column Name="PostalCode" Member="PostalCode" Storage="_PostalCode" DbType="NVarChar(10)" />
      <Column Name="Country" Member="Country" Storage="_Country" DbType="NVarChar(15)" />
      <Column Name="Salesperson" Member="Salesperson" Storage="_Salesperson" DbType="NVarChar(31) NOT NULL" CanBeNull="False" />
      <Column Name="OrderID" Member="OrderID" Storage="_OrderID" DbType="Int NOT NULL IDENTITY" />
      <Column Name="OrderDate" Member="OrderDate" Storage="_OrderDate" DbType="DateTime" />
      <Column Name="RequiredDate" Member="RequiredDate" Storage="_RequiredDate" DbType="DateTime" />
      <Column Name="ShippedDate" Member="ShippedDate" Storage="_ShippedDate" DbType="DateTime" />
      <Column Name="ShipperName" Member="ShipperName" Storage="_ShipperName" DbType="NVarChar(40) NOT NULL" CanBeNull="False" />
      <Column Name="ProductID" Member="ProductID" Storage="_ProductID" DbType="Int NOT NULL" />
      <Column Name="ProductName" Member="ProductName" Storage="_ProductName" DbType="NVarChar(40) NOT NULL" CanBeNull="False" />
      <Column Name="UnitPrice" Member="UnitPrice" Storage="_UnitPrice" DbType="Money NOT NULL" />
      <Column Name="Quantity" Member="Quantity" Storage="_Quantity" DbType="SmallInt NOT NULL" />
      <Column Name="Discount" Member="Discount" Storage="_Discount" DbType="Real NOT NULL" />
      <Column Name="ExtendedPrice" Member="ExtendedPrice" Storage="_ExtendedPrice" DbType="Money" />
      <Column Name="Freight" Member="Freight" Storage="_Freight" DbType="Money" />
    </Type>
  </Table>
  <Table Name="Order Details">
    <Type Name="nwind.OrderDetail">
      <Column Name="OrderID" Member="OrderID" Storage="_OrderID" DbType="Int NOT NULL" IsPrimaryKey="True" />
      <Column Name="ProductID" Member="ProductID" Storage="_ProductID" DbType="Int NOT NULL" IsPrimaryKey="True" />
      <Column Name="UnitPrice" Member="UnitPrice" Storage="_UnitPrice" DbType="Money NOT NULL" />
      <Column Name="Quantity" Member="Quantity" Storage="_Quantity" DbType="SmallInt NOT NULL" />
      <Column Name="Discount" Member="Discount" Storage="_Discount" DbType="Real NOT NULL" />
      <Association Name="FK_Order_Details_Orders" Member="Order" Storage="_Order" ThisKey="OrderID" OtherTable="Orders" OtherKey="OrderID" IsForeignKey="True" />
      <Association Name="FK_Order_Details_Products" Member="Product" Storage="_Product" ThisKey="ProductID" OtherTable="Products" OtherKey="ProductID" IsForeignKey="True" />
    </Type>
  </Table>
  <Table Name="Order Details Extended">
    <Type Name="nwind.OrderDetailsExtended">
      <Column Name="OrderID" Member="OrderID" Storage="_OrderID" DbType="Int NOT NULL" />
      <Column Name="ProductID" Member="ProductID" Storage="_ProductID" DbType="Int NOT NULL" />
      <Column Name="ProductName" Member="ProductName" Storage="_ProductName" DbType="NVarChar(40) NOT NULL" CanBeNull="False" />
      <Column Name="UnitPrice" Member="UnitPrice" Storage="_UnitPrice" DbType="Money NOT NULL" />
      <Column Name="Quantity" Member="Quantity" Storage="_Quantity" DbType="SmallInt NOT NULL" />
      <Column Name="Discount" Member="Discount" Storage="_Discount" DbType="Real NOT NULL" />
      <Column Name="ExtendedPrice" Member="ExtendedPrice" Storage="_ExtendedPrice" DbType="Money" />
    </Type>
  </Table>
  <Table Name="Order Subtotals">
    <Type Name="nwind.OrderSubtotal">
      <Column Name="OrderID" Member="OrderID" Storage="_OrderID" DbType="Int NOT NULL" />
      <Column Name="Subtotal" Member="Subtotal" Storage="_Subtotal" DbType="Money" />
    </Type>
  </Table>
  <Table Name="Orders">
    <Type Name="nwind.Order">
      <Column Name="OrderID" Member="OrderID" Storage="_OrderID" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="True" IsDBGenerated="True" AutoSync="OnInsert" />
      <Column Name="CustomerID" Member="CustomerID" Storage="_CustomerID" DbType="NChar(5)" />
      <Column Name="EmployeeID" Member="EmployeeID" Storage="_EmployeeID" DbType="Int" />
      <Column Name="OrderDate" Member="OrderDate" Storage="_OrderDate" DbType="DateTime" />
      <Column Name="RequiredDate" Member="RequiredDate" Storage="_RequiredDate" DbType="DateTime" />
      <Column Name="ShippedDate" Member="ShippedDate" Storage="_ShippedDate" DbType="DateTime" />
      <Column Name="ShipVia" Member="ShipVia" Storage="_ShipVia" DbType="Int" />
      <Column Name="Freight" Member="Freight" Storage="_Freight" DbType="Money" />
      <Column Name="ShipName" Member="ShipName" Storage="_ShipName" DbType="NVarChar(40)" />
      <Column Name="ShipAddress" Member="ShipAddress" Storage="_ShipAddress" DbType="NVarChar(60)" />
      <Column Name="ShipCity" Member="ShipCity" Storage="_ShipCity" DbType="NVarChar(15)" />
      <Column Name="ShipRegion" Member="ShipRegion" Storage="_ShipRegion" DbType="NVarChar(15)" />
      <Column Name="ShipPostalCode" Member="ShipPostalCode" Storage="_ShipPostalCode" DbType="NVarChar(10)" />
      <Column Name="ShipCountry" Member="ShipCountry" Storage="_ShipCountry" DbType="NVarChar(15)" />
      <Association Name="FK_Order_Details_Orders" Member="OrderDetails" Storage="_OrderDetails" ThisKey="OrderID" OtherTable="Order Details" OtherKey="OrderID" DeleteRule="NO ACTION" />
      <Association Name="FK_Orders_Customers" Member="Customer" Storage="_Customer" ThisKey="CustomerID" OtherTable="Customers" OtherKey="CustomerID" IsForeignKey="True" />
      <Association Name="FK_Orders_Employees" Member="Employee" Storage="_Employee" ThisKey="EmployeeID" OtherTable="Employees" OtherKey="EmployeeID" IsForeignKey="True" />
      <Association Name="FK_Orders_Shippers" Member="Shipper" Storage="_Shipper" ThisKey="ShipVia" OtherTable="Shippers" OtherKey="ShipperID" IsForeignKey="True" />
    </Type>
  </Table>
  <Table Name="Orders Qry">
    <Type Name="nwind.OrdersQry">
      <Column Name="OrderID" Member="OrderID" Storage="_OrderID" DbType="Int NOT NULL IDENTITY" />
      <Column Name="CustomerID" Member="CustomerID" Storage="_CustomerID" DbType="NChar(5)" />
      <Column Name="EmployeeID" Member="EmployeeID" Storage="_EmployeeID" DbType="Int" />
      <Column Name="OrderDate" Member="OrderDate" Storage="_OrderDate" DbType="DateTime" />
      <Column Name="RequiredDate" Member="RequiredDate" Storage="_RequiredDate" DbType="DateTime" />
      <Column Name="ShippedDate" Member="ShippedDate" Storage="_ShippedDate" DbType="DateTime" />
      <Column Name="ShipVia" Member="ShipVia" Storage="_ShipVia" DbType="Int" />
      <Column Name="Freight" Member="Freight" Storage="_Freight" DbType="Money" />
      <Column Name="ShipName" Member="ShipName" Storage="_ShipName" DbType="NVarChar(40)" />
      <Column Name="ShipAddress" Member="ShipAddress" Storage="_ShipAddress" DbType="NVarChar(60)" />
      <Column Name="ShipCity" Member="ShipCity" Storage="_ShipCity" DbType="NVarChar(15)" />
      <Column Name="ShipRegion" Member="ShipRegion" Storage="_ShipRegion" DbType="NVarChar(15)" />
      <Column Name="ShipPostalCode" Member="ShipPostalCode" Storage="_ShipPostalCode" DbType="NVarChar(10)" />
      <Column Name="ShipCountry" Member="ShipCountry" Storage="_ShipCountry" DbType="NVarChar(15)" />
      <Column Name="CompanyName" Member="CompanyName" Storage="_CompanyName" DbType="NVarChar(40) NOT NULL" CanBeNull="False" />
      <Column Name="Address" Member="Address" Storage="_Address" DbType="NVarChar(60)" />
      <Column Name="City" Member="City" Storage="_City" DbType="NVarChar(15)" />
      <Column Name="Region" Member="Region" Storage="_Region" DbType="NVarChar(15)" />
      <Column Name="PostalCode" Member="PostalCode" Storage="_PostalCode" DbType="NVarChar(10)" />
      <Column Name="Country" Member="Country" Storage="_Country" DbType="NVarChar(15)" />
    </Type>
  </Table>
  <Table Name="Product Sales for 1997">
    <Type Name="nwind.ProductSalesFor1997">
      <Column Name="CategoryName" Member="CategoryName" Storage="_CategoryName" DbType="NVarChar(15) NOT NULL" CanBeNull="False" />
      <Column Name="ProductName" Member="ProductName" Storage="_ProductName" DbType="NVarChar(40) NOT NULL" CanBeNull="False" />
      <Column Name="ProductSales" Member="ProductSales" Storage="_ProductSales" DbType="Money" />
    </Type>
  </Table>
  <Table Name="Products">
    <Type Name="nwind.Product">
      <Column Name="ProductID" Member="ProductID" Storage="_ProductID" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="True" IsDBGenerated="True" AutoSync="OnInsert" />
      <Column Name="ProductName" Member="ProductName" Storage="_ProductName" DbType="NVarChar(40) NOT NULL" CanBeNull="False" />
      <Column Name="SupplierID" Member="SupplierID" Storage="_SupplierID" DbType="Int" />
      <Column Name="CategoryID" Member="CategoryID" Storage="_CategoryID" DbType="Int" />
      <Column Name="QuantityPerUnit" Member="QuantityPerUnit" Storage="_QuantityPerUnit" DbType="NVarChar(20)" />
      <Column Name="UnitPrice" Member="UnitPrice" Storage="_UnitPrice" DbType="Money" />
      <Column Name="UnitsInStock" Member="UnitsInStock" Storage="_UnitsInStock" DbType="SmallInt" />
      <Column Name="UnitsOnOrder" Member="UnitsOnOrder" Storage="_UnitsOnOrder" DbType="SmallInt" />
      <Column Name="ReorderLevel" Member="ReorderLevel" Storage="_ReorderLevel" DbType="SmallInt" />
      <Column Name="Discontinued" Member="Discontinued" Storage="_Discontinued" DbType="Bit NOT NULL" />
      <Association Name="FK_Order_Details_Products" Member="OrderDetails" Storage="_OrderDetails" ThisKey="ProductID" OtherTable="Order Details" OtherKey="ProductID" DeleteRule="NO ACTION" />
      <Association Name="FK_Products_Categories" Member="Category" Storage="_Category" ThisKey="CategoryID" OtherTable="Categories" OtherKey="CategoryID" IsForeignKey="True" />
      <Association Name="FK_Products_Suppliers" Member="Supplier" Storage="_Supplier" ThisKey="SupplierID" OtherTable="Suppliers" OtherKey="SupplierID" IsForeignKey="True" />
    </Type>
  </Table>
  <Table Name="Products Above Average Price">
    <Type Name="nwind.ProductsAboveAveragePrice">
      <Column Name="ProductName" Member="ProductName" Storage="_ProductName" DbType="NVarChar(40) NOT NULL" CanBeNull="False" />
      <Column Name="UnitPrice" Member="UnitPrice" Storage="_UnitPrice" DbType="Money" />
    </Type>
  </Table>
  <Table Name="Products by Category">
    <Type Name="nwind.ProductsByCategory">
      <Column Name="CategoryName" Member="CategoryName" Storage="_CategoryName" DbType="NVarChar(15) NOT NULL" CanBeNull="False" />
      <Column Name="ProductName" Member="ProductName" Storage="_ProductName" DbType="NVarChar(40) NOT NULL" CanBeNull="False" />
      <Column Name="QuantityPerUnit" Member="QuantityPerUnit" Storage="_QuantityPerUnit" DbType="NVarChar(20)" />
      <Column Name="UnitsInStock" Member="UnitsInStock" Storage="_UnitsInStock" DbType="SmallInt" />
      <Column Name="Discontinued" Member="Discontinued" Storage="_Discontinued" DbType="Bit NOT NULL" />
    </Type>
  </Table>
  <Table Name="Quarterly Orders">
    <Type Name="nwind.QuarterlyOrder">
      <Column Name="CustomerID" Member="CustomerID" Storage="_CustomerID" DbType="NChar(5)" />
      <Column Name="CompanyName" Member="CompanyName" Storage="_CompanyName" DbType="NVarChar(40)" />
      <Column Name="City" Member="City" Storage="_City" DbType="NVarChar(15)" />
      <Column Name="Country" Member="Country" Storage="_Country" DbType="NVarChar(15)" />
    </Type>
  </Table>
  <Table Name="Region">
    <Type Name="nwind.Region">
      <Column Name="RegionID" Member="RegionID" Storage="_RegionID" DbType="Int NOT NULL" IsPrimaryKey="True" />
      <Column Name="RegionDescription" Member="RegionDescription" Storage="_RegionDescription" DbType="NChar(50) NOT NULL" CanBeNull="False" />
      <Association Name="FK_Territories_Region" Member="Territories" Storage="_Territories" ThisKey="RegionID" OtherTable="Territories" OtherKey="RegionID" DeleteRule="NO ACTION" />
    </Type>
  </Table>
  <Table Name="Sales by Category">
    <Type Name="nwind.SalesByCategory">
      <Column Name="CategoryID" Member="CategoryID" Storage="_CategoryID" DbType="Int NOT NULL IDENTITY" />
      <Column Name="CategoryName" Member="CategoryName" Storage="_CategoryName" DbType="NVarChar(15) NOT NULL" CanBeNull="False" />
      <Column Name="ProductName" Member="ProductName" Storage="_ProductName" DbType="NVarChar(40) NOT NULL" CanBeNull="False" />
      <Column Name="ProductSales" Member="ProductSales" Storage="_ProductSales" DbType="Money" />
    </Type>
  </Table>
  <Table Name="Sales Totals by Amount">
    <Type Name="nwind.SalesTotalsByAmount">
      <Column Name="SaleAmount" Member="SaleAmount" Storage="_SaleAmount" DbType="Money" />
      <Column Name="OrderID" Member="OrderID" Storage="_OrderID" DbType="Int NOT NULL IDENTITY" />
      <Column Name="CompanyName" Member="CompanyName" Storage="_CompanyName" DbType="NVarChar(40) NOT NULL" CanBeNull="False" />
      <Column Name="ShippedDate" Member="ShippedDate" Storage="_ShippedDate" DbType="DateTime" />
    </Type>
  </Table>
  <Table Name="Shippers">
    <Type Name="nwind.Shipper">
      <Column Name="ShipperID" Member="ShipperID" Storage="_ShipperID" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="True" IsDBGenerated="True" AutoSync="OnInsert" />
      <Column Name="CompanyName" Member="CompanyName" Storage="_CompanyName" DbType="NVarChar(40) NOT NULL" CanBeNull="False" />
      <Column Name="Phone" Member="Phone" Storage="_Phone" DbType="NVarChar(24)" />
      <Association Name="FK_Orders_Shippers" Member="Orders" Storage="_Orders" ThisKey="ShipperID" OtherTable="Orders" OtherKey="ShipVia" DeleteRule="NO ACTION" />
    </Type>
  </Table>
  <Table Name="Summary of Sales by Quarter">
    <Type Name="nwind.SummaryOfSalesByQuarter">
      <Column Name="ShippedDate" Member="ShippedDate" Storage="_ShippedDate" DbType="DateTime" />
      <Column Name="OrderID" Member="OrderID" Storage="_OrderID" DbType="Int NOT NULL IDENTITY" />
      <Column Name="Subtotal" Member="Subtotal" Storage="_Subtotal" DbType="Money" />
    </Type>
  </Table>
  <Table Name="Summary of Sales by Year">
    <Type Name="nwind.SummaryOfSalesByYear">
      <Column Name="ShippedDate" Member="ShippedDate" Storage="_ShippedDate" DbType="DateTime" />
      <Column Name="OrderID" Member="OrderID" Storage="_OrderID" DbType="Int NOT NULL IDENTITY" />
      <Column Name="Subtotal" Member="Subtotal" Storage="_Subtotal" DbType="Money" />
    </Type>
  </Table>
  <Table Name="Suppliers">
    <Type Name="nwind.Supplier">
      <Column Name="SupplierID" Member="SupplierID" Storage="_SupplierID" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="True" IsDBGenerated="True" AutoSync="OnInsert" />
      <Column Name="CompanyName" Member="CompanyName" Storage="_CompanyName" DbType="NVarChar(40) NOT NULL" CanBeNull="False" />
      <Column Name="ContactName" Member="ContactName" Storage="_ContactName" DbType="NVarChar(30)" />
      <Column Name="ContactTitle" Member="ContactTitle" Storage="_ContactTitle" DbType="NVarChar(30)" />
      <Column Name="Address" Member="Address" Storage="_Address" DbType="NVarChar(60)" />
      <Column Name="City" Member="City" Storage="_City" DbType="NVarChar(15)" />
      <Column Name="Region" Member="Region" Storage="_Region" DbType="NVarChar(15)" />
      <Column Name="PostalCode" Member="PostalCode" Storage="_PostalCode" DbType="NVarChar(10)" />
      <Column Name="Country" Member="Country" Storage="_Country" DbType="NVarChar(15)" />
      <Column Name="Phone" Member="Phone" Storage="_Phone" DbType="NVarChar(24)" />
      <Column Name="Fax" Member="Fax" Storage="_Fax" DbType="NVarChar(24)" />
      <Column Name="HomePage" Member="HomePage" Storage="_HomePage" DbType="NText" UpdateCheck="Never" />
      <Association Name="FK_Products_Suppliers" Member="Products" Storage="_Products" ThisKey="SupplierID" OtherTable="Products" OtherKey="SupplierID" DeleteRule="NO ACTION" />
    </Type>
  </Table>
  <Table Name="Territories">
    <Type Name="nwind.Territory">
      <Column Name="TerritoryID" Member="TerritoryID" Storage="_TerritoryID" DbType="NVarChar(20) NOT NULL" CanBeNull="False" IsPrimaryKey="True" />
      <Column Name="TerritoryDescription" Member="TerritoryDescription" Storage="_TerritoryDescription" DbType="NChar(50) NOT NULL" CanBeNull="False" />
      <Column Name="RegionID" Member="RegionID" Storage="_RegionID" DbType="Int NOT NULL" />
      <Association Name="FK_EmployeeTerritories_Territories" Member="EmployeeTerritories" Storage="_EmployeeTerritories" ThisKey="TerritoryID" OtherTable="EmployeeTerritories" OtherKey="TerritoryID" DeleteRule="NO ACTION" />
      <Association Name="FK_Territories_Region" Member="Region" Storage="_Region" ThisKey="RegionID" OtherTable="Region" OtherKey="RegionID" IsForeignKey="True" />
    </Type>
  </Table>
  <StoredProcedure Name="Customers By City" Method="CustomersByCity">
    <Parameter Name="param1" Parameter="param1" DbType="NVarChar(20)" />
    <Type Name="nwind.CustomersByCityResult">
      <Column Name="CustomerID" Member="CustomerID" Storage="_CustomerID" DbType="NChar(5)" />
      <Column Name="ContactName" Member="ContactName" Storage="_ContactName" DbType="NVarChar(30)" />
      <Column Name="CompanyName" Member="CompanyName" Storage="_CompanyName" DbType="NVarChar(40)" />
      <Column Name="City" Member="City" Storage="_City" DbType="NVarChar(15)" />
    </Type>
  </StoredProcedure>
  <StoredProcedure Name="Customers Count By Region" Method="CustomersCountByRegion">
    <Parameter Name="param1" Parameter="param1" DbType="NVarChar(15)" />
  </StoredProcedure>
  <StoredProcedure Name="CustOrderHist" Method="CustOrderHist">
    <Parameter Name="CustomerID" Parameter="customerID" DbType="NChar(5)" />
    <Type Name="nwind.CustOrderHistResult">
      <Column Name="ProductName" Member="ProductName" Storage="_ProductName" DbType="NVarChar(40)" />
      <Column Name="Total" Member="Total" Storage="_Total" DbType="Int" />
    </Type>
  </StoredProcedure>
  <StoredProcedure Name="CustOrdersDetail" Method="CustOrdersDetail">
    <Parameter Name="OrderID" Parameter="orderID" DbType="Int" />
    <Type Name="nwind.CustOrdersDetailResult">
      <Column Name="ProductName" Member="ProductName" Storage="_ProductName" DbType="NVarChar(40)" />
      <Column Name="UnitPrice" Member="UnitPrice" Storage="_UnitPrice" DbType="Money" />
      <Column Name="Quantity" Member="Quantity" Storage="_Quantity" DbType="SmallInt" />
      <Column Name="Discount" Member="Discount" Storage="_Discount" DbType="Int" />
      <Column Name="ExtendedPrice" Member="ExtendedPrice" Storage="_ExtendedPrice" DbType="Money" />
    </Type>
  </StoredProcedure>
  <StoredProcedure Name="CustOrdersOrders" Method="CustOrdersOrders">
    <Parameter Name="CustomerID" Parameter="customerID" DbType="NChar(5)" />
    <Type Name="nwind.CustOrdersOrdersResult">
      <Column Name="OrderID" Member="OrderID" Storage="_OrderID" DbType="Int" />
      <Column Name="OrderDate" Member="OrderDate" Storage="_OrderDate" DbType="DateTime" />
      <Column Name="RequiredDate" Member="RequiredDate" Storage="_RequiredDate" DbType="DateTime" />
      <Column Name="ShippedDate" Member="ShippedDate" Storage="_ShippedDate" DbType="DateTime" />
    </Type>
  </StoredProcedure>
  <StoredProcedure Name="CustOrderTotal" Method="CustOrderTotal">
    <Parameter Name="CustomerID" Parameter="customerID" DbType="NChar(5)" />
    <Parameter Name="TotalSales" Parameter="totalSales" DbType="Money" />
  </StoredProcedure>
  <StoredProcedure Name="Employee Sales by Country" Method="EmployeeSalesByCountry">
    <Parameter Name="Beginning_Date" Parameter="beginning_Date" DbType="DateTime" />
    <Parameter Name="Ending_Date" Parameter="ending_Date" DbType="DateTime" />
    <Type Name="nwind.EmployeeSalesByCountryResult">
      <Column Name="Country" Member="Country" Storage="_Country" DbType="NVarChar(15)" />
      <Column Name="LastName" Member="LastName" Storage="_LastName" DbType="NVarChar(20)" />
      <Column Name="FirstName" Member="FirstName" Storage="_FirstName" DbType="NVarChar(10)" />
      <Column Name="ShippedDate" Member="ShippedDate" Storage="_ShippedDate" DbType="DateTime" />
      <Column Name="OrderID" Member="OrderID" Storage="_OrderID" DbType="Int" />
      <Column Name="SaleAmount" Member="SaleAmount" Storage="_SaleAmount" DbType="Money" />
    </Type>
  </StoredProcedure>
  <StoredProcedure Name="Get Customer And Orders" Method="GetCustomerAndOrders">
    <Parameter Name="CustomerID" Parameter="customerID" DbType="NChar(5)" />
    <Type Name="nwind.GetCustomerAndOrdersResult1">
      <Column Name="CustomerID" Member="CustomerID" Storage="_CustomerID" DbType="NChar(5)" />
      <Column Name="CompanyName" Member="CompanyName" Storage="_CompanyName" DbType="NVarChar(40)" />
      <Column Name="ContactName" Member="ContactName" Storage="_ContactName" DbType="NVarChar(30)" />
      <Column Name="ContactTitle" Member="ContactTitle" Storage="_ContactTitle" DbType="NVarChar(30)" />
      <Column Name="Address" Member="Address" Storage="_Address" DbType="NVarChar(60)" />
      <Column Name="City" Member="City" Storage="_City" DbType="NVarChar(15)" />
      <Column Name="Region" Member="Region" Storage="_Region" DbType="NVarChar(15)" />
      <Column Name="PostalCode" Member="PostalCode" Storage="_PostalCode" DbType="NVarChar(10)" />
      <Column Name="Country" Member="Country" Storage="_Country" DbType="NVarChar(15)" />
      <Column Name="Phone" Member="Phone" Storage="_Phone" DbType="NVarChar(24)" />
      <Column Name="Fax" Member="Fax" Storage="_Fax" DbType="NVarChar(24)" />
    </Type>
    <Type Name="nwind.GetCustomerAndOrdersResult2">
      <Column Name="OrderID" Member="OrderID" Storage="_OrderID" DbType="Int" />
      <Column Name="CustomerID" Member="CustomerID" Storage="_CustomerID" DbType="NChar(5)" />
      <Column Name="EmployeeID" Member="EmployeeID" Storage="_EmployeeID" DbType="Int" />
      <Column Name="OrderDate" Member="OrderDate" Storage="_OrderDate" DbType="DateTime" />
      <Column Name="RequiredDate" Member="RequiredDate" Storage="_RequiredDate" DbType="DateTime" />
      <Column Name="ShippedDate" Member="ShippedDate" Storage="_ShippedDate" DbType="DateTime" />
      <Column Name="ShipVia" Member="ShipVia" Storage="_ShipVia" DbType="Int" />
      <Column Name="Freight" Member="Freight" Storage="_Freight" DbType="Money" />
      <Column Name="ShipName" Member="ShipName" Storage="_ShipName" DbType="NVarChar(40)" />
      <Column Name="ShipAddress" Member="ShipAddress" Storage="_ShipAddress" DbType="NVarChar(60)" />
      <Column Name="ShipCity" Member="ShipCity" Storage="_ShipCity" DbType="NVarChar(15)" />
      <Column Name="ShipRegion" Member="ShipRegion" Storage="_ShipRegion" DbType="NVarChar(15)" />
      <Column Name="ShipPostalCode" Member="ShipPostalCode" Storage="_ShipPostalCode" DbType="NVarChar(10)" />
      <Column Name="ShipCountry" Member="ShipCountry" Storage="_ShipCountry" DbType="NVarChar(15)" />
    </Type>
  </StoredProcedure>
  <UserDefinedFunction Name="dbo.MinUnitPriceByCategory" Method="MinUnitPriceByCategory" DbType="Money">
    <Parameter Name="categoryID" Parameter="categoryID" DbType="Int" />
  </UserDefinedFunction>
  <TableValuedFunction Name="ProductsUnderThisUnitPrice" Method="ProductsUnderThisUnitPrice">
    <Parameter Name="price" Parameter="price" DbType="Money" />
    <Type Name="nwind.ProductsUnderThisUnitPriceResult">
      <Column Name="ProductID" Member="ProductID" Storage="_ProductID" DbType="Int" />
      <Column Name="ProductName" Member="ProductName" Storage="_ProductName" DbType="NVarChar(40)" />
      <Column Name="SupplierID" Member="SupplierID" Storage="_SupplierID" DbType="Int" />
      <Column Name="CategoryID" Member="CategoryID" Storage="_CategoryID" DbType="Int" />
      <Column Name="QuantityPerUnit" Member="QuantityPerUnit" Storage="_QuantityPerUnit" DbType="NVarChar(20)" />
      <Column Name="UnitPrice" Member="UnitPrice" Storage="_UnitPrice" DbType="Money" />
      <Column Name="UnitsInStock" Member="UnitsInStock" Storage="_UnitsInStock" DbType="SmallInt" />
      <Column Name="UnitsOnOrder" Member="UnitsOnOrder" Storage="_UnitsOnOrder" DbType="SmallInt" />
      <Column Name="ReorderLevel" Member="ReorderLevel" Storage="_ReorderLevel" DbType="SmallInt" />
      <Column Name="Discontinued" Member="Discontinued" Storage="_Discontinued" DbType="Bit" />
    </Type>
  </TableValuedFunction>
  <StoredProcedure Name="Sales by Year" Method="SalesByYear">
    <Parameter Name="Beginning_Date" Parameter="beginning_Date" DbType="DateTime" />
    <Parameter Name="Ending_Date" Parameter="ending_Date" DbType="DateTime" />
    <Type Name="nwind.SalesByYearResult">
      <Column Name="ShippedDate" Member="ShippedDate" Storage="_ShippedDate" DbType="DateTime" />
      <Column Name="OrderID" Member="OrderID" Storage="_OrderID" DbType="Int" />
      <Column Name="Subtotal" Member="Subtotal" Storage="_Subtotal" DbType="Money" />
      <Column Name="Year" Member="Year" Storage="_Year" DbType="NVarChar(30)" />
    </Type>
  </StoredProcedure>
  <StoredProcedure Name="SalesByCategory" Method="SalesByCategory">
    <Parameter Name="CategoryName" Parameter="categoryName" DbType="NVarChar(15)" />
    <Parameter Name="OrdYear" Parameter="ordYear" DbType="NVarChar(4)" />
    <Type Name="nwind.SalesByCategoryResult">
      <Column Name="ProductName" Member="ProductName" Storage="_ProductName" DbType="NVarChar(40)" />
      <Column Name="TotalPurchase" Member="TotalPurchase" Storage="_TotalPurchase" DbType="Decimal(38,2)" />
    </Type>
  </StoredProcedure>
  <StoredProcedure Name="Ten Most Expensive Products" Method="TenMostExpensiveProducts">
    <Type Name="nwind.TenMostExpensiveProductsResult">
      <Column Name="TenMostExpensiveProducts" Member="TenMostExpensiveProducts" Storage="_TenMostExpensiveProducts" DbType="NVarChar(40)" />
      <Column Name="UnitPrice" Member="UnitPrice" Storage="_UnitPrice" DbType="Money" />
    </Type>
  </StoredProcedure>
  <UserDefinedFunction Name="dbo.TotalProductUnitPriceByCategory" Method="TotalProductUnitPriceByCategory" DbType="Money">
    <Parameter Name="categoryID" Parameter="categoryID" DbType="Int" />
  </UserDefinedFunction>
  <StoredProcedure Name="Whole Or Partial Customers Set" Method="WholeOrPartialCustomersSet">
    <Parameter Name="param1" Parameter="param1" DbType="Int" />
    <Type Name="nwind.WholeOrPartialCustomersSetResult1">
      <Column Name="CustomerID" Member="CustomerID" Storage="_CustomerID" DbType="NChar(5)" />
      <Column Name="CompanyName" Member="CompanyName" Storage="_CompanyName" DbType="NVarChar(40)" />
      <Column Name="ContactName" Member="ContactName" Storage="_ContactName" DbType="NVarChar(30)" />
      <Column Name="ContactTitle" Member="ContactTitle" Storage="_ContactTitle" DbType="NVarChar(30)" />
      <Column Name="Address" Member="Address" Storage="_Address" DbType="NVarChar(60)" />
      <Column Name="City" Member="City" Storage="_City" DbType="NVarChar(15)" />
      <Column Name="Region" Member="Region" Storage="_Region" DbType="NVarChar(15)" />
      <Column Name="PostalCode" Member="PostalCode" Storage="_PostalCode" DbType="NVarChar(10)" />
      <Column Name="Country" Member="Country" Storage="_Country" DbType="NVarChar(15)" />
      <Column Name="Phone" Member="Phone" Storage="_Phone" DbType="NVarChar(24)" />
      <Column Name="Fax" Member="Fax" Storage="_Fax" DbType="NVarChar(24)" />
    </Type>
    <Type Name="nwind.WholeOrPartialCustomersSetResult2">
      <Column Name="CustomerID" Member="CustomerID" Storage="_CustomerID" DbType="NChar(5)" />
      <Column Name="ContactName" Member="ContactName" Storage="_ContactName" DbType="NVarChar(30)" />
      <Column Name="CompanyName" Member="CompanyName" Storage="_CompanyName" DbType="NVarChar(40)" />
    </Type>
  </StoredProcedure>
</Database>